CURSORs and selects with parameters
| От | Dan Sugalski |
|---|---|
| Тема | CURSORs and selects with parameters |
| Дата | |
| Msg-id | a06210204be37fa6e9f1c@[172.24.18.155] обсуждение исходный текст |
| Ответы |
Re: CURSORs and selects with parameters
|
| Список | pgsql-general |
When using cursors through the libpq interface, do I need to be
passing in the parameters when I'm FETCHing from them?
I've got some code that uses PQexecParams and does the equivalent of:
DECLARE a_cursor CURSOR FOR SELECT foo, bar FROM baz WHERE field = $1
FETCH NEXT a_cursor
but when I get to the FETCH I'm getting back the error:
ERROR: no value found for parameter 1
which is fair enough, as I'm not *passing* in any parameters to the
fetch. (Yes, I double-checked--the parameter count in the
PQexecParams call is 1 for the cursor declaration, and 0 for the
fetch) Do I have to?
--
Dan
--------------------------------------it's like this-------------------
Dan Sugalski even samurai
dan@sidhe.org have teddy bears and even
teddy bears get drunk
В списке pgsql-general по дате отправления: